{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Allocation","Expenditures","Allocation sample","Expenses sample"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Allocation","index":0,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,1,6,4],[7,2,7,3]]}
["(Nom du GMSR/CADSS)"]
["Tableau des revenus et dépenses - Services à l'enfance (Page 1)"]
["Pour l'exercice terminé le 31 décembre, 2013"]
["(Non vérifié)"]
[]
[]
[null,"REVENUS"]
[null,"Ministère de l'Éducation","La loi de partage des coûts",null,"Total"]
[null,"(Contrat de service modifié le plus récent)",null,"(Calculé)","(Calculé)"]
[]
["Flexibilité totale"]
[]
["1.1 - Prestation des services de base (100% provincial)",null,0,{"$f":"B13/(1-C13)*C13","v":0},{"$f":"B13+D13","v":0}]
["1.2 - Prestation des services de base - Partage des coûts 80/20",null,0.2,0,0]
["1.3 - Prestation des services de base - Partage des coûts 50/50 - Administration",null,0.5,0,0]
["2.1 - Langage",null,0,0,0]
["2.2 - Autochtones",null,0,0,0]
["2.3 - Coût de la vie",null,0,0,0]
["2.4 - Communautés rurales et éloignées",null,0,0,0]
["2.5 -Transition vers la maternelle et le jardin d’enfants à temps plein",null,0,0,0]
["2.10 - Réparations et entretien",null,0,0,0]
["2.11 - Ajustment pour l'utilisation",null,0,0,0]
["2.12 - Ajustment pour le plafond",null,0,0,0]
[]
["Total (subvention à flexibilité totale)",{"$f":"SUBTOTAL(9,B13:B23)","v":0},null,{"$f":"SUBTOTAL(9,D13:D23)","v":0},{"$f":"SUBTOTAL(9,E13:E23)","v":0}]
[]
["2.6 - Transformation",null,0,{"$f":"B27/(1-C27)*C27","v":0},{"$f":"B27+D27","v":0}]
[]
["Flexibilité limitée"]
[]
["2.7 - Renforcement de la capacité",null,0,{"$f":"B31/(1-C31)*C31","v":0},{"$f":"B31+D31","v":0}]
["4.1 - Réaménagements des immobilisations",null,0,{"$f":"B32/(1-C32)*C32","v":0},{"$f":"B32+D32","v":0}]
["2.8 - Petites installations de distribution d’eau",null,0,{"$f":"B33/(1-C33)*C33","v":0},{"$f":"B33+D33","v":0}]
[]
["Total (subvention à flexibilité limitée)",{"$f":"SUBTOTAL(9,B31:B33)","v":0},null,{"$f":"SUBTOTAL(9,D31:D33)","v":0},{"$f":"SUBTOTAL(9,E31:E33)","v":0}]
["Aucune Flexibilité"]
[]
["2.9 - Territoires non érigés en municipalité",null,0,{"$f":"B38/(1-C38)*C38","v":0},{"$f":"B38+D38","v":0}]
[]
["TOTAL",{"$f":"B25+B27+B35+B38","v":0},null,{"$f":"D25+D27+D35+D38","v":0},{"$f":"E25+E27+E35+E38","v":0}]

{"sheet":"Expenditures","index":1,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,0,5,15],[6,1,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,12],[6,13,6,15]]}
["(Name of Entity)"]
["Schedule of Revenues and Expenditures – Children’s Services (Page 2)"]
["For the year ended December 31, 2013"]
["(Unaudited)"]
[]
["EXPENDITURES BY AUSPICE"]
[null,"Non-Profit",null,null,"Profit",null,null,"Directly Operated",null,null,"Other",null,null,"Total Expenditures"]
[null,"Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures","Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures","Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures","Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures","Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures"]
[null,"Sch 2.3, Col. 1","Sch 2.3, Col. 2 + 3","Calculated\n (Sch 2.3, Col. 4)","Sch 2.3, Col. 5","Sch 2.3, Col. 6 + 7","Calculated\n (Sch 2.3, Col. 8)","Sch 2.3, Col. 9","Sch 2.3, Col. 10+11+12","Calculated\n (Sch 2.3, Col. 13)","Sch 2.3, Col. 14","Sch 2.3, Col. 15","Calculated\n (Sch 2.3, Col. 16)","Calculated","Calculated","Calculated"]
[]
["Full Flexibility"]
[]
["1.1 - General Operating",null,null,{"$f":"B13+C13","v":0},null,null,{"$f":"E13+F13","v":0},null,null,{"$f":"H13+I13","v":0},null,null,{"$f":"K13+L13","v":0},{"$f":"B13+E13+H13+K13","v":0},{"$f":"C13+F13+I13+L13","v":0},{"$f":"N13+O13","v":0}]
["1.2 - Regular Fee Subsidy",null,null,{"$f":"B14+C14","v":0},null,null,{"$f":"E14+F14","v":0},null,null,{"$f":"H14+I14","v":0},null,null,{"$f":"K14+L14","v":0},{"$f":"B14+E14+H14+K14","v":0},{"$f":"C14+F14+I14+L14","v":0},{"$f":"N14+O14","v":0}]
["1.3 - Extended Day Fee Subsidy",null,null,{"$f":"B15+C15","v":0},null,null,{"$f":"E15+F15","v":0},null,null,{"$f":"H15+I15","v":0},null,null,{"$f":"K15+L15","v":0},0,0,{"$f":"N15+O15","v":0}]
["1.4 - Recreation Fee Subsidy",null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
["1.5 - Ontario Works Formal",null,null,{"$f":"B17+C17","v":0},null,null,0,null,null,0,null,null,0,0,0,0]
["1.6 - Ontario Works Informal",null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
["1.7 - Pay Equity Memorandum",null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
["1.8 - Special Needs Resourcing",null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
["1.9 - Administration",null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
["1.10 - Repairs and Maintenance",null,null,0,null,null,0,null,null,0,null,null,0,0,0,0]
["1.11 - Play-based Material",null,null,{"$f":"B23+C23","v":0},null,null,{"$f":"E23+F23","v":0},null,null,{"$f":"H23+I23","v":0},null,null,{"$f":"K23+L23","v":0},0,0,{"$f":"N23+O23","v":0}]
["1.14 - Miscellaneous",null,null,{"$f":"B24+C24","v":0},null,null,{"$f":"E24+F24","v":0},null,null,{"$f":"H24+I24","v":0},null,null,{"$f":"K24+L24","v":0},0,0,{"$f":"N24+O24","v":0}]
[]
["Total (full flexibility)",{"$f":"SUBTOTAL(9,B13:B24)","v":0},{"$f":"SUBTOTAL(9,C13:C24)","v":0},{"$f":"SUBTOTAL(9,D13:D23)","v":0},{"$f":"SUBTOTAL(9,E13:E24)","v":0},{"$f":"SUBTOTAL(9,F13:F24)","v":0},0,{"$f":"SUBTOTAL(9,H13:H24)","v":0},{"$f":"SUBTOTAL(9,I13:I24)","v":0},0,{"$f":"SUBTOTAL(9,K13:K24)","v":0},0,0,0,0,0]
[]
["1.13 - Transformation",null,null,{"$f":"B28+C28","v":0},null,null,{"$f":"E28+F28","v":0},null,null,{"$f":"H28+I28","v":0},null,null,{"$f":"K28+L28","v":0},{"$f":"B28+E28+H28+K28","v":0},{"$f":"C28+F28+I28+L28","v":0},{"$f":"N28+O28","v":0}]
[]
["Limited Flexibility"]
[]
["1.12 - Capacity Building",null,null,{"$f":"B32+C32","v":0},null,null,{"$f":"E32+F32","v":0},null,null,{"$f":"H32+I32","v":0},null,null,{"$f":"K32+L32","v":0},{"$f":"B32+E32+H32+K32","v":0},0,{"$f":"N32+O32","v":0}]
["2.1 - Capital Retrofits",null,null,{"$f":"B33+C33","v":0},null,null,0,null,null,{"$f":"H33+I33","v":0},null,null,{"$f":"K33+L33","v":0},0,0,{"$f":"N33+O33","v":0}]
["3.1 - Small Water Works",null,null,{"$f":"B34+C34","v":0},null,null,0,null,null,{"$f":"H34+I34","v":0},null,null,{"$f":"K34+L34","v":0},0,0,{"$f":"N34+O34","v":0}]
[]
["Total (limited flexibility)",{"$f":"SUBTOTAL(9,B32:B34)","v":0},0,0,0,0,0,0,0,{"$f":"SUBTOTAL(9,J32:J34)","v":0},0,0,0,0,{"$f":"SUBTOTAL(9,O32:O34)","v":0},0]
["No Flexibility"]
[]
["3.2 - Territory without Municipal Organization",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K39+L39","v":0},{"$f":"B39+E39+H39+K39","v":0},{"$f":"C39+F39+I39+L39","v":0},{"$f":"N39+O39","v":0}]
[]
["TOTAL",{"$f":"SUBTOTAL(9,B13:B40)","v":0},{"$f":"SUBTOTAL(9,C13:C40)","v":0},{"$f":"SUBTOTAL(9,D13:D40)","v":0},{"$f":"SUBTOTAL(9,E13:E40)","v":0},{"$f":"SUBTOTAL(9,F13:F40)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(9,O13:O40)","v":0},0]

{"sheet":"Allocation sample","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,2,7,3],[6,1,6,4]]}
["(Name of Entity)"]
["Schedule of Revenues and Expenditures – Children’s Services (Page 1)"]
["For the year ended December 31, 2013"]
["(Unaudited)"]
[]
[]
[null,"REVENUES"]
[null,"Ministry of Education","Legislated Cost Share",null,"Total"]
[null,"(Most recent Amended Service agreement)",null,"(Calculated)","(Calculated)"]
[]
["Full Flexibility"]
[]
["1.1 - Core Services Delivery (100% provincial)",100000,0,{"$f":"B13/(1-C13)*C13","v":0},{"$f":"B13+D13","v":100000}]
["1.2 - Core Services Delivery - Cost Shared Requirement 80/20",20000,0.2,5000,25000]
["1.3 - Core Service Delivery - Cost Shared Requirement 50/50 - Administration",15000,0.5,15000,30000]
["2.1 - Language",25000,0,0,25000]
["2.2 - Aboriginal",1000,0,0,1000]
["2.3 - Cost of Living",2000,0,0,2000]
["2.4 - Rural/Remote",3000,0,0,3000]
["2.5 - FDK Transition",4000,0,0,4000]
["2.10 - Repairs and Maintenance",5000,0,0,5000]
["2.11 - Utilization Adjustment",6000,0,0,6000]
["2.12 - Capping Adjustment",7000,0,0,7000]
[]
["Total (full flexibility)",{"$f":"SUBTOTAL(9,B13:B23)","v":188000},null,{"$f":"SUBTOTAL(9,D13:D23)","v":20000},{"$f":"SUBTOTAL(9,E13:E23)","v":208000}]
[]
["2.6 - Transformation",2000,0,{"$f":"B27/(1-C27)*C27","v":0},{"$f":"B27+D27","v":2000}]
[]
["Limited Flexibility"]
[]
["2.7 - Capacity Building",6000,0,{"$f":"B31/(1-C31)*C31","v":0},{"$f":"B31+D31","v":6000}]
["4.1 - Capital Retrofits",7000,0,{"$f":"B32/(1-C32)*C32","v":0},{"$f":"B32+D32","v":7000}]
["2.8 - Small Water Works",8000,0,{"$f":"B33/(1-C33)*C33","v":0},{"$f":"B33+D33","v":8000}]
[]
["Total (limited flexibility)",{"$f":"SUBTOTAL(9,B31:B33)","v":21000},null,{"$f":"SUBTOTAL(9,D31:D33)","v":0},{"$f":"SUBTOTAL(9,E31:E33)","v":21000}]
["No Flexibility"]
[]
["2.9 - Territory Without Municipal Organization",0,0,{"$f":"B38/(1-C38)*C38","v":0},{"$f":"B38+D38","v":0}]
[]
["TOTAL",{"$f":"B25+B27+B35+B38","v":211000},null,{"$f":"D25+D27+D35+D38","v":20000},{"$f":"E25+E27+E35+E38","v":231000}]

{"sheet":"Expenses sample","index":3,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,0,5,15],[6,1,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,12],[6,13,6,15]]}
["(Name of Entity)"]
["Schedule of Revenues and Expenditures – Children’s Services (Page 2)"]
["For the year ended December 31, 2013"]
["(Unaudited)"]
[]
["EXPENDITURES BY AUSPICE"]
[null,"Non-Profit",null,null,"Profit",null,null,"Directly Operated",null,null,"Other",null,null,"Total Expenditures"]
[null,"Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures","Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures","Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures","Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures","Gross Expenditures","Offsetting Revenues (Parent contribution/other offsetting)","Adjusted Gross Expenditures"]
[null,"Sch 2.3, Col. 1","Sch 2.3, Col. 2 + 3","Calculated\n (Sch 2.3, Col. 4)","Sch 2.3, Col. 5","Sch 2.3, Col. 6 + 7","Calculated\n (Sch 2.3, Col. 8)","Sch 2.3, Col. 9","Sch 2.3, Col. 10+11+12","Calculated\n (Sch 2.3, Col. 13)","Sch 2.3, Col. 14","Sch 2.3, Col. 15","Calculated\n (Sch 2.3, Col. 16)","Calculated","Calculated","Calculated"]
[]
["Full Flexibility"]
[]
["1.1 - General Operating",20,-1,{"$f":"B13+C13","v":19},120,-11,{"$f":"E13+F13","v":109},220,-31,{"$f":"H13+I13","v":189},320,-41,{"$f":"K13+L13","v":279},{"$f":"B13+E13+H13+K13","v":680},{"$f":"C13+F13+I13+L13","v":-84},{"$f":"N13+O13","v":596}]
["1.2 - Regular Fee Subsidy",30,-2,{"$f":"B14+C14","v":28},130,-12,{"$f":"E14+F14","v":118},230,-32,{"$f":"H14+I14","v":198},330,-42,{"$f":"K14+L14","v":288},{"$f":"B14+E14+H14+K14","v":720},{"$f":"C14+F14+I14+L14","v":-88},{"$f":"N14+O14","v":632}]
["1.3 - Extended Day Fee Subsidy",40,-3,{"$f":"B15+C15","v":37},140,-13,{"$f":"E15+F15","v":127},240,-33,{"$f":"H15+I15","v":207},340,-43,{"$f":"K15+L15","v":297},760,-92,{"$f":"N15+O15","v":668}]
["1.4 - Recreation Fee Subsidy",50,-4,46,150,-14,136,250,-34,216,350,-44,306,800,-96,704]
["1.5 - Ontario Works Formal",60,-5,{"$f":"B17+C17","v":55},160,-15,145,260,-35,225,360,-45,315,840,-100,740]
["1.6 - Ontario Works Informal",70,-6,64,170,-16,154,270,-36,234,370,-46,324,880,-104,776]
["1.7 - Pay Equity Memorandum",80,-7,73,180,-17,163,280,-37,243,380,-47,333,920,-108,812]
["1.8 - Special Needs Resourcing",90,-8,82,190,-18,172,290,-38,252,390,-48,342,960,-112,848]
["1.9 - Administration",100,-9,91,200,-19,181,300,-39,261,400,-49,351,1000,-116,884]
["1.10 - Repairs and Maintenance",110,-10,100,210,-20,190,310,-40,270,410,-50,360,1040,-120,920]
["1.11 - Play-based Material",120,-11,{"$f":"B23+C23","v":109},220,-21,{"$f":"E23+F23","v":199},320,-41,{"$f":"H23+I23","v":279},420,-51,{"$f":"K23+L23","v":369},1080,-124,{"$f":"N23+O23","v":956}]
["1.14 - Miscellaneous",120,-11,{"$f":"B24+C24","v":109},220,-21,{"$f":"E24+F24","v":199},320,-41,{"$f":"H24+I24","v":279},420,-51,{"$f":"K24+L24","v":369},1080,-124,{"$f":"N24+O24","v":956}]
[]
["Total (full flexibility)",{"$f":"SUBTOTAL(9,B13:B24)","v":890},-77,813,2090,-197,1893,3290,-437,2853,4490,-557,3933,10760,-1268,9492]
[]
["1.13 - Transformation",2,-1,{"$f":"B28+C28","v":1},2,-1,{"$f":"E28+F28","v":1},2,-1,{"$f":"H28+I28","v":1},2,-1,{"$f":"K28+L28","v":1},{"$f":"B28+E28+H28+K28","v":8},{"$f":"C28+F28+I28+L28","v":-4},{"$f":"N28+O28","v":4}]
[]
["Limited Flexibility"]
[]
["1.12 - Capacity Building",50,-1,{"$f":"B32+C32","v":49},70,-1,{"$f":"E32+F32","v":69},90,-1,{"$f":"H32+I32","v":89},110,-1,{"$f":"K32+L32","v":109},{"$f":"B32+E32+H32+K32","v":320},-4,{"$f":"N32+O32","v":316}]
["2.1 - Capital Retrofits",60,-1,{"$f":"B33+C33","v":59},80,-1,79,100,-1,{"$f":"H33+I33","v":99},120,-1,{"$f":"K33+L33","v":119},360,-4,{"$f":"N33+O33","v":356}]
["3.1 - Small Water Works",70,-1,{"$f":"B34+C34","v":69},90,-1,89,110,-1,{"$f":"H34+I34","v":109},130,-1,{"$f":"K34+L34","v":129},400,-4,{"$f":"N34+O34","v":396}]
[]
["Total (limited flexibility)",{"$f":"SUBTOTAL(9,B32:B34)","v":180},{"$f":"SUBTOTAL(9,C32:C34)","v":-3},177,240,-3,237,300,-3,297,360,-3,357,1080,{"$f":"SUBTOTAL(9,O32:O34)","v":-12},1068]
["No Flexibility"]
[]
["3.2 - Territory without Municipal Organization",null,null,null,null,null,null,null,null,null,2,-1,{"$f":"K39+L39","v":1},{"$f":"B39+E39+H39+K39","v":2},{"$f":"C39+F39+I39+L39","v":-1},{"$f":"N39+O39","v":1}]
[]
["TOTAL",{"$f":"SUBTOTAL(9,B13:B40)","v":1072},{"$f":"SUBTOTAL(9,C13:C40)","v":-81},{"$f":"SUBTOTAL(9,D13:D40)","v":991},{"$f":"SUBTOTAL(9,E13:E40)","v":2332},{"$f":"SUBTOTAL(9,F13:F40)","v":-201},2131,3592,-441,3151,4854,-562,4292,11850,{"$f":"SUBTOTAL(9,O13:O40)","v":-1285},10565]